package com.bangf.repo;

import com.bangf.domain.FpSatisfy;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface SatisfyRepo extends JpaRepository<FpSatisfy,Integer> {

    @Query(value =  "SELECT * FROM fp_satisfy " +
                    "WHERE town_id = ?1",nativeQuery = true)
    FpSatisfy findByTownId(Integer townId);
}
